CREATE PROCEDURE [dbo].[asi_PrcQueryProductPriceDetails]
    @priceSheetVersionKey uniqueidentifier,
    @productKey uniqueidentifier,
    @currencyCode nchar(3)
    AS
BEGIN
    SELECT det.PriceDetailKey
    FROM
    PriceSheetVersion ver
    INNER JOIN PriceVersionDetail verdet ON verdet.PriceSheetVersionKey=ver.PriceSheetVersionKey
    INNER JOIN PriceDetail det ON det.PriceDetailKey=verdet.PriceDetailKey
    WHERE ver.PriceSheetVersionKey=@priceSheetVersionKey
    AND det.ProductKey=@productKey
    AND det.CurrencyCode=@currencyCode
END

GO